USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0008_CREATE_TABLE]    Script Date: 11/22/2011 17:22:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_D0008_CREATE_TABLE]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_D0008_CREATE_TABLE]
GO

USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0008_CREATE_TABLE]    Script Date: 11/22/2011 17:22:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<JJ>
-- Create date: <01/08/2011>
-- Description:	<CREA TABLA>
-- =============================================
CREATE PROCEDURE [dbo].[WASP_D0008_CREATE_TABLE]

AS
--BEGIN
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[seg_proteccion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[seg_proteccion]
--GO

CREATE TABLE [dbo].[seg_proteccion] (
	RUT    char  (9),
	DV     char(1),
	NOMBRE char(50),
	AGCOLOC  numeric(2, 0) NULL ,
	NRO_CREDITO	char(9),
	INICIO_COBERTURA decimal(8,0),
	FIN_COBERTURA	decimal(8,0),
	NRO_CUOTAS	char(2),
	TLFONOPEN	char(10),
	DIRTRABAJA	char(40)

)
--GO

--END
--GO

GO

